package com.leyou.order.mapper;

import com.leyou.common.mapper.BaseMapper;
import com.leyou.order.entity.Order;
import org.apache.ibatis.annotations.Select;

import java.util.Date;
import java.util.List;

public interface OrderMapper extends BaseMapper<Order> {
    @Select("SELECT order_id FROM tb_order WHERE `status` = 1 AND `create_time` <= #{deadline}")
    List<Long> queryOverdueUnpaidOrder(Date deadline);
}